﻿CREATE TABLE [stg].[Track] (
    [TrackCode]     INT             NOT NULL,
    [Name]          NVARCHAR (200)  NOT NULL,
    [AlbumCode]     INT             NULL,
    [MediaTypeCode] INT             NOT NULL,
    [GenreCode]     INT             NULL,
    [Composer]      NVARCHAR (220)  NULL,
    [Milliseconds]  INT             NOT NULL,
    [Bytes]         INT             NULL,
    [UnitPrice]     NUMERIC (10, 2) NOT NULL,
    [TaskExecutionLogId] INT NOT NULL DEFAULT 0, 
    CONSTRAINT [PK_Track] PRIMARY KEY CLUSTERED ([TrackCode] ASC)
);

